I need your help. I'm trying to migrate a mySQL database into an Oracle database. Is there anayone who has tried this successfully? And what have you done?
Thanks a lot for your advices
kiki
You can use the Oracle Migration Workbench (http://otn.oracle.com/tech/migration/workbench/content.html) which supports MySQL.
Good morniiinng,
pabloj, thanks a lot. I'll try it immediately
kiki
Why are you migrating from MYSQL to Oracle? I am looking at a dataware house with 300 gb initially and considering what to use Mysql vs SQL Server vs Oracle. You experiance would be appricated.
a dataware house with 300 gb
I'd imagine MySQL would be the last of your options there - MS SQL and Oracle would be the better choice. It just depends on your pocket I guess.
christo
The cost while a factor is not the driving issue. I am looking or ease of implmentation and sheer performance. Why do you say not MYSQL?
The lack of advanced features, like triggers, stored procedures and most of all VIEWS make MySQL highly unsuitable for datawarehousing, believe me.
The best (from my experience):
For very large DWHs are Oracle 9i (very nice set of features, much better than 8i) and Teradata.
Midrange dwh, DB2 and Sybase.
OS: any modern *nix for stability and reliability.
I think that the most interesting opensource db for this task could be PostgreSQL.
I'm currently using MSSQL for small dwh for it's ease of use and good price/performance ratio, but the big guns are other, personally I would always go for Oracle, on Linux/Intel or SUN/USparc.
Hi,
I need your help. I'm trying to migrate a mySQL database into an Oracle database. Is there anayone who has tried this successfully? And what have you done?
Thanks a lot for your advices
kiki
I use data loader for migrating almost any data, it helps me to convert MSSQL to MYSQL, MS access to MSSQL, mysql, csv loader, foxpro and MSSQL to MS access, MYSQl, CSV, foxpro etc. In my view this is a best Data Migration Tool